﻿<%@ Page Language="VB" AutoEventWireup="false" CodeFile="parametre.aspx.vb" Inherits="parametre" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Page sans titre</title>
</head>
<body>
    <form id="form1" runat="server">
    <div align="center">
        <table width="500">
            <tr>
                <td>
                    ServerMapPath</td>
                <td>
                    <asp:Label ID="LabelPath" runat="server" Text="Label"></asp:Label></td>
                <td>
                </td>
            </tr>
            <tr>
                <td>
                </td>
                <td>
                </td>
                <td>
                </td>
            </tr>
            <tr>
                <td>
                </td>
                <td>
                </td>
                <td>
                </td>
            </tr>
        </table>
    
    </div>
        &nbsp;
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="pjid"
            DataSourceID="SqlDataSource1" EmptyDataText="Il n'y a aucun enregistrement de données à afficher.">
            <Columns>
                <asp:BoundField DataField="pjid" HeaderText="pjid" ReadOnly="True" SortExpression="pjid" />
                <asp:BoundField DataField="pjpatref" HeaderText="pjpatref" SortExpression="pjpatref" />
                <asp:BoundField DataField="pjitvref" HeaderText="pjitvref" SortExpression="pjitvref" />
                <asp:BoundField DataField="pjtype" HeaderText="pjtype" SortExpression="pjtype" />
                <asp:BoundField DataField="pjtexte" HeaderText="pjtexte" SortExpression="pjtexte" />
                <asp:BoundField DataField="pjdisc" HeaderText="pjdisc" SortExpression="pjdisc" />
                <asp:BoundField DataField="idresamu" HeaderText="idresamu" SortExpression="idresamu" />
                <asp:BoundField DataField="idteam" HeaderText="idteam" SortExpression="idteam" />
                <asp:BoundField DataField="date" HeaderText="date" SortExpression="date" />
                <asp:BoundField DataField="pjvalue" HeaderText="pjvalue" SortExpression="pjvalue" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DatabasePJConnectionString %>"
            DeleteCommand="DELETE FROM [listpj] WHERE [pjid] = @pjid" InsertCommand="INSERT INTO [listpj] ([pjid], [pjpatref], [pjitvref], [pjtype], [pjtexte], [pjdisc], [idresamu], [idteam], [date]) VALUES (@pjid, @pjpatref, @pjitvref, @pjtype, @pjtexte, @pjdisc, @idresamu, @idteam, @date)"
            ProviderName="<%$ ConnectionStrings:DatabasePJConnectionString.ProviderName %>"
            SelectCommand="SELECT [pjid], [pjpatref], [pjitvref], [pjtype], [pjtexte], [pjdisc], [pjvalue], [idresamu], [idteam], [date] FROM [listpj]"
            UpdateCommand="UPDATE [listpj] SET [pjpatref] = @pjpatref, [pjitvref] = @pjitvref, [pjtype] = @pjtype, [pjtexte] = @pjtexte, [pjdisc] = @pjdisc, [idresamu] = @idresamu, [idteam] = @idteam, [date] = @date WHERE [pjid] = @pjid">
            <InsertParameters>
                <asp:Parameter Name="pjid" Type="String" />
                <asp:Parameter Name="pjpatref" Type="String" />
                <asp:Parameter Name="pjitvref" Type="String" />
                <asp:Parameter Name="pjtype" Type="String" />
                <asp:Parameter Name="pjtexte" Type="String" />
                <asp:Parameter Name="pjdisc" Type="String" />
                <asp:Parameter Name="idresamu" Type="String" />
                <asp:Parameter Name="idteam" Type="String" />
                <asp:Parameter Name="date" Type="DateTime" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="pjpatref" Type="String" />
                <asp:Parameter Name="pjitvref" Type="String" />
                <asp:Parameter Name="pjtype" Type="String" />
                <asp:Parameter Name="pjtexte" Type="String" />
                <asp:Parameter Name="pjdisc" Type="String" />
                <asp:Parameter Name="idresamu" Type="String" />
                <asp:Parameter Name="idteam" Type="String" />
                <asp:Parameter Name="date" Type="DateTime" />
                <asp:Parameter Name="pjid" Type="String" />
            </UpdateParameters>
            <DeleteParameters>
                <asp:Parameter Name="pjid" Type="String" />
            </DeleteParameters>
        </asp:SqlDataSource>
    </form>
</body>
</html>
